/*
 Navicat Premium Data Transfer

 Source Server         : 本地_mysql
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : renren_cloud_tenant

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 11/01/2022 17:54:16
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for work_assembly_notice
-- ----------------------------
DROP TABLE IF EXISTS `work_assembly_notice`;
CREATE TABLE `work_assembly_notice` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '主题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci COMMENT '内容',
  `thumbs_up_num` int DEFAULT NULL COMMENT '点赞数',
  `follow_num` int DEFAULT NULL COMMENT '关注数',
  `sending_range_id` int DEFAULT NULL COMMENT '发送区域ID',
  `sending_range` int DEFAULT NULL COMMENT '发送区域',
  `sending_terminal` int DEFAULT NULL COMMENT '发送终端',
  `sending_methods` varchar(255) DEFAULT NULL COMMENT '发送方式',
  `consignee_type` int DEFAULT NULL COMMENT '收件人类型',
  `creator` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '创建人',
  `create_time` datetime(6) DEFAULT NULL COMMENT '创建时间\r\n',
  `logical_delete` bit(1) NOT NULL DEFAULT b'1' COMMENT '逻辑删除',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='信息通知';

-- ----------------------------
-- Records of work_assembly_notice
-- ----------------------------
BEGIN;
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
